Sum total income for each unique client and chart it!?

Hi menick,

SUMIF() will do the job.

the formula in Table 2::B2=

SUMIF(Table 1::A,A2,Table 1::B)

It is filled down.

quinn

menick wrote:

and chart it to visualise which customers bring in the most cash.

To see what charts might work best I recommend having a look at the 'Charting Basics' template at File > New in your menu. Generally, the approach is to select the cells in the table to be charted, in your case the second table, and then choose a chart type, either after clicking 'Chart' in the toolbar or choosing from the menu Insert > Chart and choose the type.

SG

Hi menick,

I don't understand what you are imagining when you say "do this without a second table". Where would your generated list of unique clients appear? If you want, you can use SUMIF() in your first table.

quinn

Hi menick,

Here is an approach that uses an index column in your invoiced table. This can be hidden.

C2= IF(COUNTIF(A$2:A2,A2)=1,C1+1,C1)

Filled down.

You can use INDEX/MATCH to bring your unique clients over to a second table.

A2= INDEX(Table 1::A,MATCH(ROW(cell)−1,Table 1::C,-1))

Filled down.

You can hide the error cells (included for when your client list expands) with a filter or by wrapping the formula with IFERROR() once you get it working.

quinn

Hi menick,

Is this what you are looking for?

In my region Numbers uses commas but it is an easy transition to make. I still like to create formulas in Numbers by pointing and clicking. It avoids many syntax errors that way.

quinn

Hi menick,

Glad everything is working for you. Is your question solved?

edit: I guess it is! thanks for the green check!

quinn

Hi menick,

Check back when you start exploring the charting options. There are some people here with some real expertise.

quinn